Model Videos
The following tutorial videos cover Model topics.
Model Pro Overview
A walk-through demo on how to use the data preparation and modeling tools.
Model Lite Overview
An overview of the Model Lite interface for non-technical building of ETLs and data models.
Connect to Microsoft OLAP or Tabular
A quick demo on how to connect to Microsoft Analysis Services (OLAP or Tabular).
Connect to a SQL Database
A quick demo on connecting to and querying an existing relational database.
Direct Connect
Learn how to create a direct model to add a quick data model to an existing database.
Data Model Structures
An explanation of Data Models and Data Security.
Regular Hierarchies
Build SQL-based regular hierarchies in Model and navigate them in Discover.
Parent-Child Hierarchies
Build SQL-based Parent-child hierarchies in Model and navigate them in Discover.
Custom Maps
Create custom maps, based on your own custom shapes.
Data Statistics and Quality
Review statistics for the columns in a given table and take suggested actions, like adding time intelligence.
Python Data and Stock Charts
Learn how to download stock data in Model and use it to build charts in Discover.
Custom Column Calculations
Create or manipulate column values, or perform calculations on existing column values.
Unpivot Tool
Use the Unpivot tool to tabularize cross-tabbed data sets so they can be used in the analytics engine properly.
Extract SAP data with Glue
Use Datavard's Glue integration with Pyramid to extract raw SAP ERP data.
Buiding MS Tabular Models
Use Pyramid to design and build a Microsoft Tabular Model. Then use the model in Discover and Formulate.
Buiding Exasol Models
Use Pyramid to design and build an Exasol database and analytical model. Then use the model in Discover and Formulate.
Data Security
Learn how to set Data and Model security.
Shared Tools
These videos cover tools that work in multiple apps in the application.
Personalized Data Catalogs
See how to customize data models (and associated data catalogs) both as a user and as an admin.
Data Model Validator
Use the validator to ensure that the semantic model in Pyramid is aligned with the target database.
Sample Data
Some of the videos use the "billings" Excel data set. You can download it here for your own testing.